7732 S.E. 99th Ct.
 PAdams, Alvan A.
4455 N.W. 44th Pl.
Coral Springs, FL
Baxter, Nancy T.
7788 S.W. 33rd Ave.
Plantation, FL
Brown, Peter A.
3301 N. 99th St.
Pompano Beach, FL
Chandler, Randall
Apt 10B, 1400 E. 41 Ct.
Pompano Beach, FL
Dalton, Barry L.
4729 N.E. 11 Pl.
Deerfield Beach, FL
Evans, Martha Q.
7732 S.E. 99th Ct.
Hallandale Beach, FL
Franklin, Dennis J. 9201 W. 4th Pl.
Ft. Lauderdale, FL
Gold, Harvey B.
76201 S.W. 1st St.
Plantation, FL
Harrison, Adam P.
78612 N.W. 55th St.
Coral Springs, FL
Henry, Albert T.
99011 E. 5th St.
Ft. Lauderdale, FL
ADDRESS
CITY_ST
Inman, Barnard K.
87097 N.E. 4th Pl.
Deerfield Beach, FL
Jackson, Mary C.
30190 N.W. 88th Ter.
Coral Springs, FL
Jones, Andrew
 S. 12th Pl.
Ft. Lauderdale, FL
Kendall, Jennifer L.Apt C. 14123 W. 7th Ct.
Ft. Lauderdale, FL
Lawson, Robert T.
77612 N.W. 99 Pl.
Coral Springs, FL
Mathers, Gerald A.  88032 N.W. 14th Ct.
Coral Springs, FL
Nobel, Alfred P.
55182 N.W. 27th Ter.
Coral Springs, FL
Picket, Wilson W.
1230 W. 55th Rd.
Tamarac, FL
Simmons, John D.
3215 N.E. 3rd St.
Deerfield Beach, FL
Smith, Randy
1314 W. 21st St.
Ft. Lauderdale, FL
Wilson, Susan
7788 E. 77th Ter.
Ft. Lauderdale, FL
PHONES.DAT
Record:15
Status:Active
Order:NAME_KEY
 PSmith, Randy
1314 W. 21st St.
Ft. Lauderdale, FL
Jones, Andrew
 S. 12th Pl.
Ft. Lauderdale, FL
Wilson, Susan
7788 E. 77th Ter.
Ft. Lauderdale, FL
Brown, Peter A.
3301 N. 99th St.
Pompano Beach, FL
Adams, Alvan A.
4455 N.W. 44th Pl.
Coral Springs, FL
Baxter, Nancy T.
7788 S.W. 33rd Ave.
Plantation, FL
Picket, Wilson W.
1230 W. 55th Rd.
Tamarac, FL
Simmons, John D.
3215 N.E. 3rd St.
Deerfield Beach, FL
Chandler, Randall
Apt 10B, 1400 E. 41 Ct.
Pompano Beach, FL
Dalton, Barry L.
4729 N.E. 11 Pl.
Deerfield Beach, FL
ADDRESS
CITY_ST
Evans, Martha Q.
7732 S.E. 99th Ct.
Hallandale Beach, FL
Franklin, Dennis J. 9201 W. 4th Pl.
Ft. Lauderdale, FL
Gold, Harvey B.
76201 S.W. 1st St.
Plantation, FL
Henry, Albert T.
99011 E. 5th St.
Ft. Lauderdale, FL
Inman, Barnard K.
87097 N.E. 4th Pl.
Deerfield Beach, FL
Jackson, Mary C.
30190 N.W. 88th Ter.
Coral Springs, FL
Kendall, Jennifer L.Apt C. 14123 W. 7th Ct.
Ft. Lauderdale, FL
Harrison, Adam P.
78612 N.W. 55th St.
Coral Springs, FL
Lawson, Robert T.
77612 N.W. 99 Pl.
Coral Springs, FL
Mathers, Gerald A.  88032 N.W. 14th Ct.
Coral Springs, FL
Nobel, Alfred P.
55182 N.W. 27th Ter.
Coral Springs, FL
PHONES.DAT
Record:11
Status:Active
Order:Record Number 
Hallandale Beach, FL
Converting dBase file
The CLARION Converter
Input Type :Clarion
Clarion  dBase  DIF  BASIC
Input File :
Output Type:
dBaseII dBase
 DIF  BASIC
Output File:
Source File:
 This is Converter's Base window.  You must first specify the type  
 of the input file to be converted.  If you choose dBase, Converter 
 will determine if it is dBaseII or dBase
 format.  To specify a  
 file type, you would use the arrow keys to position the selector
 bar over your choice, and then press Enter.
 At the Input file field, you must specify the path, name, and
 extension of the file that you want to convert.  If you omit the
 path, the current directory is supplied automatically.  Extensions 
 default according to the Input type: .DAT for Clarion, .DBF for
 dBase, .DIF for DIF, and .BAS for BASIC.
 If you cannot remember the name of the file you want to convert,
 you can access the File Selection window at this point by pressing 
 Enter.
 As in all Clarion
 utilities, the File  
 Selection window can 
 be used to assist
 you in locating the  
 file you wish to use.
 You simply use the
 arrow keys to move
 the selector bar to  
 the file you want,
 and then press Enter.
 If you selected something other than Clarion as an input type
 (which we did) then Converter automatically sets the output type 
 to Clarion and then moves to the Output File field.
 Here you will type in the path, name, and extension of the new
 file that you want Converter to create.  If you omit the path,
 the current directory is used.  If you omit the extension, the
 default is supplied according to the output type. In this case,  
 the output type is Clarion, so the default extension is .DAT.
 If you use the name of an existing file, it will be replaced.
 To search for a filename, leave the field blank and press Enter. 
 Converter warns us that the output file already exists.  Sometime  
 this will save us from making a mistake.  We could press Esc to go 
 back to the Output File field and pick a different file, but this  
 time, we want to replace the existing file, so we continue.
 If your input data file is a dBaseII, dBase
, DIF, or BASIC file, 
 Converter will automatically create the source statements for a
 Clarion FILE structure, declaring a file to match your new Clarion  
 data file.  (If your input data file is a Clarion file, Converter
 skips this line.)
 Converter initializes the Source File field with the name of the
 output file plus the extension .TMP.  To accept this filename, all 
 we have to do is press Enter.
 Here is what the source statement structure created by Converter
 looks like.  This concludes the Converter tutorial.
1:  03 57 08 12 05 00 00 00 E1 00 2D 00 00 00 00 00
11:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
21:  43 4E 41 4D 45 00 00 00 00 00 00 43 05 00 FB 72
CNAME
31:  19 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00
41:  43 46 4C 54 5F 4E 4F 00 00 00 00 43 1E 00 FB 72
CFLT_NO
51:  03 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00
61:  43 44 45 50 5F 43 49 54 59 00 00 43 21 00 FB 72
CDEP_CITY..C!.
71:  03 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00
81:  43 44 45 53 5F 43 49 54 59 00 00 43 24 00 FB 72
CDES_CITY..C$.
91:  03 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00
A1:  43 46 4C 54 5F 44 41 54 45 00 00 44 27 00 FB 72
CFLT_DATE..D'.
B1:  08 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00
C1:  43 4E 4F 5F 53 45 41 54 53 00 00 4E 2F 00 FB 72
CNO_SEATS..N/.
D1:  02 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00
E1:  0D 20 4C 4F 55 49 53 20 20 20 20 20 20 20 20 20
. LOUIS
F1:  20 20 20 20 20 20 20 20 20 20 20 31 30 31 4C 41
101LA
101:  58 41 54 4C 31 39 38 35 31 32 30 32 31 30 20 50
XATL1985120210 P
:  41 55 4C 20 20 20 20 20 20 20 20 20 20 20 20 20
121:  20 20 20 20 20 20 20 20 39 35 31 41 54 4C 42 4F
951ATLBO
131:  53 31 39 38 35 31 32 30 33 20 31 20 4E 45 4C 53
S19851203 1 NELS
141:  4F 4E 20 54 53 4F 20 20 20 20 20 20 20 20 20 20
ON TSO
 ]CUSTOMER.DBF A1
 -HEX
Entering DOS mode
Input file:
 0Sequence  :
Press Enter to scan file
File size:
 (File date: 09/11/87
 (File time:  01:00AM
 PHN:NAME
 PHN:ADDRESS
 PHN:CITY_STATE
 PHN:ZIP
 PHN:PHONE
The CLARION Filer
  Source file:
  Label
  Input file :
  Output file:
 This is the Filer tutorial.
 Filer reads a file layout from a Clarion source program and  
 creates the Clarion files necessary to contain the records,  
 keys, and memo fields declared in the file structure.
 The new files can be populated with records from an existing 
 file.  Filer reads the record layout from the header of the  
 existing file and rearranges each record as is necessary to  
 match the new record layout.
 This is Filer's base window.
 Using Designer, we have added a second address field 
 to our PHONEBK file.  (PHONEBK is declared in the
 PHONES.CLA module.)  We eliminated the field named
 ADDRESS and added two fields named ADDRESS1 and
 ADDRESS2.  We want to create a new PHONEBK file.
 We want to change the layout of PHONEBK, but  
 we don't want to lose our data--we have added 
 quite a few records to the file.  So we will  
 use the old PHONEBK file as input.
 The left column shows the fields in the new file
 (the file we are creating).  The right column shows 
 the fields from the old file that will be used by
 the new file.  They are fields with the same name.  
 We are about to lose the data from ADDRESS in the  
 old file because there is no field named ADDRESS
 in the new file.  We want ADDRESS1 to get the data 
 from ADDRESS.  ADDRESS2 is a new field and should  
 be set to spaces.  We press down arrow and Enter.  
 We select ADDRESS as the input
 field to be used for ADDRESS1 in 
 the output file.  We press down  
 arrow twice and Enter.
 This is about what we had in mind.  NAME, CITY_STATE, ZIP, and
 PHONE will be moved from the old file to the new file.  ADDRESS1 
 comes from ADDRESS.  And ADDRESS2 will be set to spaces.  Now we 
 press Ctrl-Enter to convert the file.
 Our new PHONEBK file now has two address fields. 
 And we converted the file in minutes--without
 losing any data.
 This completes the Filer tutorial.  Let's return 
 to the tutorial menu.
Get Output Field
From Input Field
1  NAME
1  NAME
2  ADDRESS1
(New Field)
3  ADDRESS2
(New Field)
4  CITY_STATE
3  CITY_STATE
5  ZIP
4  ZIP
6  PHONE
5  PHONE
 	Press Enter to Change Input Field
Press Ctrl-Enter to Convert
(New Field)
1  NAME
2  ADDRESS
3  CITY_STATE
4  ZIP
5  PHONE
 11  NAME
1  NAME
2  ADDRESS1
2  ADDRESS
3  ADDRESS2
(New Field)
 	4  CITY_STATE
3  CITY_STATE
5  ZIP
4  ZIP
6  PHONE
5  PHONE
C:\GL\CUSTOMER.DBF
*.DBF
WORK\
REPORTS\
AVAL_FLT.DBF
CUSTOMER.DBF
 #Move Field
1314 W. 21st St.
Smith, Randy
 S. 12th Pl.
Jones, Andrew
7788 E. 77th Ter.
Wilson, Susan
3301 N. 99th St.
Brown, Peter A.
4455 N.W. 44th Pl.
Adams, Alvan A.
7788 S.W. 33rd Ave.
Baxter, Nancy T.
1230 W. 55th Rd.
Picket, Wilson W.
3215 N.E. 3rd St.
Simmons, John D.
Apt 10B, 1400 E. 41 Ct.
Chandler, Randall
4729 N.E. 11 Pl.
Dalton, Barry L.
ADDRESS
7732 S.E. 99th Ct.
Evans, Martha Q.
9201 W. 4th Pl.
Franklin, Dennis J. 76201 S.W. 1st St.
Gold, Harvey B.
99011 E. 5th St.
Henry, Albert T.
87097 N.E. 4th Pl.
Inman, Barnard K.
30190 N.W. 88th Ter.
Jackson, Mary C.
Apt C. 14123 W. 7th Ct.
Kendall, Jennifer L.78612 N.W. 55th St.
Harrison, Adam P.
77612 N.W. 99 Pl.
Lawson, Robert T.
88032 N.W. 14th Ct.
Mathers, Gerald A.  55182 N.W. 27th Ter.
Nobel, Alfred P.
1314 W. 21st St.
Ft. Lauderdale, FL
Smith, Randy
 S. 12th Pl.
Ft. Lauderdale, FL
Jones, Andrew
7788 E. 77th Ter.
Ft. Lauderdale, FL
Wilson, Susan
3301 N. 99th St.
Pompano Beach, FL
Brown, Peter A.
4455 N.W. 44th Pl.
Coral Springs, FL
Adams, Alvan A.
7788 S.W. 33rd Ave.
Plantation, FL
Baxter, Nancy T.
1230 W. 55th Rd.
Tamarac, FL
Picket, Wilson W.
3215 N.E. 3rd St.
Deerfield Beach, FL
Simmons, John D.
Apt 10B, 1400 E. 41 Ct.
Pompano Beach, FL
Chandler, Randall
4729 N.E. 11 Pl.
Deerfield Beach, FL
Dalton, Barry L.
ADDRESS
CITY_ST
7732 S.E. 99th Ct.
Hallandale Beach, FL
Evans, Martha Q.
9201 W. 4th Pl.
Ft. Lauderdale, FL
Franklin, Dennis J. 76201 S.W. 1st St.
Plantation, FL
Gold, Harvey B.
99011 E. 5th St.
Ft. Lauderdale, FL
Henry, Albert T.
87097 N.E. 4th Pl.
Deerfield Beach, FL
Inman, Barnard K.
30190 N.W. 88th Ter.
Coral Springs, FL
Jackson, Mary C.
Apt C. 14123 W. 7th Ct.
Ft. Lauderdale, FL
Kendall, Jennifer L.78612 N.W. 55th St.
Coral Springs, FL
Harrison, Adam P.
77612 N.W. 99 Pl.
Coral Springs, FL
Lawson, Robert T.
88032 N.W. 14th Ct.
Coral Springs, FL
Mathers, Gerald A.  55182 N.W. 27th Ter.
Coral Springs, FL
Nobel, Alfred P.
Evans, Martha Q.
Inman, Barnard K.
Record Number
NAME_KEY
 P33033
 :33034
 :33035
 :33064
 :33065
 :33011
 :33044
3056754352
 :33079
3054346342
 :33064
3056541234
 :33033
3056789123
 :ZIP
 	PHONE
 ?33912
3056879123
 :s12
 	s12
 A33031
3056786453
 :33901
3054632718
 :33033
3056859400
 :33088
3053896512
 :33071
3054671243
 :33765
3054678392
 :33071
3054678392
 :33065
3057331299
 :33071
3053658836
 :33065
3057853620
 <PHONES.DAT
Record:11
Status:Active
Order:Record Number 
File definition for converted file CUSTOMER.DAT 
FILE,NAME('CUSTOMER.DAT')
RECORD
 CNAME
STRING(25)
 CFLT_NO
STRING(3)
 CDEP_CITY
STRING(3)
 CDES_CITY
STRING(3)
 CFLT_DATE
STRING(8)
 CNO_SEATS
 (305)
-1212  (305)
-3131  (305)
-7766  (305)
-3113  (305)
  (305)
-8899  (305)675-4352  (305)434-6342  (305)654-1234  (305)678-9123 PHONE
(305)687-9123 P (
 (305)678-6453  (305)463-2718  (305)685-9400  (305)389-6512  (305)467-1243  (305)467-8392  (305)467-8392  (305)733-1299  (305)365-8836  (305)785-3620 
3056879123  
 (305)687-9123 
*.DBF
PHONE\
TUTORIAL\
AVAL_FLT.DBF
CUSTOMER.DBF
*.DAT
WORK\
REPORTS\
CUSTOMER.DAT
ACCOUNT.DAT
C:\GL\CUSTOMER.DAT
The CLARION Scanner
  Input file:
  Sequence  :
 This is Scanner's Base window.  If, at any point, you want to exit  
 from Scanner, press Esc from the Input file line.  The Input file
 field is where you specify the file to be scanned.  This field will 
 usually contain the name of the active data file, remembered by
 Clarion.  If you omit the path, the current directory will be used. 
 If you omit the extension, .DAT will be used.  To access the the
 File Selection window, leave the field blank or enter a pattern and 
 press Enter.
 We can change the viewing format of a field  
 by using Ctrl-F to change the picture format.
 The next page shows how the PHONE field
 would look if the picture format was changed 
 using Ctrl-F from s12 to p (
 p.  
 You can also use Ctrl-L to change the 
 label area.  In this manner you can
 design a custom viewing format for
 any of the fields.  These formats are 
 then remembered by Scanner for this
 file in an options file with the
 extension .SCN.  Then each time you
 scan the file, you will be able to
 view it in the format you have
 designed.
 The following demonstrates the use of 
 Cursor left to return to the first
 set of fields on the prior screen.
 There are several commands that operate on
 the current record:
 Ctrl-D 
 Delete a record.
 Ctrl-R 
 Release a "Held" record.
 Ctrl-U 
 Undelete a deleted record.
 There are also several commands that operate 
 on the current field of the current record:  
 Ctrl-C 
 Change the contents of a field.
 Ctrl-F 
 Change the format of a field.
 Ctrl-L 
 Change a field's display label.
 Ctrl-M 
 Move a field column for display.  
 Ctrl-S displays the Search and Replace window.  This command can be  
 used to search all records to find a specific value in the current
 field.  You can optionally replace the value with a different value. 
 Use Ctrl-N to continue the search to the Next matching record.
 In addition to changing the format and label of a field,  
 you can also change the order of the fields with the
 Ctrl-M command.  Ctrl-M is used to move the current field 
 to another position on the screen, exchanging positions
 with the field to the left or right.  The following
 demonstrates using Ctrl-M and Cursor right to move the
 Name field two fields to the right.
 Changes made with Ctrl-M are also remembered 
 in the .SCN options file for this data file, 
 providing you with yet another way to
 customize the display format for your file.  
 Now let's change the viewing
 sequence.  This file has a  
 key declared -- NAME_KEY.
 To use this key as the new  
 sequence, press Enter.
 Now the records are ordered in ascending 
 sequence by the NAME field.
 Some of the other commands available for 
 Clarion data files are:
 Ctrl-J 
 Jump to a record number.
 Ctrl-P 
 Print a formatted report.
 Ctrl-T 
 Edit a Text (Memo) field.
 Now let's scan a file that  
 is not a Clarion data file. 
 This shows how we might
 have used the File Selection
 window to locate a dBase
 file for scanning.  When we 
 press Enter, this will then 
 be the active file.
 Scanner detects that the
 file is not a Clarion file 
 and it automatically
 switches to DOS mode.
 We can use the File 
 Selection window to 
 locate the file to  
 be scanned.  When
 the selector bar is 
 over the file you
 want, simply press  
 Enter.
 Hex area 
 Text area 
Decimal
address
Active and
Shadow cursors 
Ctrl-T for Text
Ctrl-H for Hex 
 In DOS mode, Scanner displays the decimal address at the left,
 the hexadecimal format in the center, and the text format at the 
 right.  Changes can be made in Text or Hex mode.
 Cursor controls move the active cursor.  Use Esc, Ctrl-Esc,  
 or Ctrl-Q to exit DOS mode.  Here are some of the commands
 available in DOS mode:
 Ctrl-A 
 Add a byte to the end of the file.
 Ctrl-C 
 Change a byte within a file.
 Ctrl-E 
 Create a new End of File.
 Ctrl-H 
 Activate the Hex cursor.
 Ctrl-J 
 Jump to a new byte address.
 Ctrl-N 
 Search for the next occurrence of the search byte.
 Ctrl-P 
 Print a Scanner report.
 Ctrl-S 
 Search and replace.
 Ctrl-T 
 Activate the Text cursor.
 This concludes the tutorial on Scanner. 
 Scanner will show you your  
 data ordered according to
 the sequence you choose in  
 the Sequence window.  The
 first choice is always
 Record Number.  Record
 number order is the order in
 which the records are stored
 in the file.
 This often correlates to the
 order in which the records  
 were added to the file.
 To choose Record Number as  
 the sequence, simply press  
 Enter.
 When a Clarion data file is selected for scanning, various file
 statistics and the source statement structure of the file are
 displayed.  Large source statement structures can be scrolled with 
 up and down arrow.  To continue, simply press Enter.
 This is the Record Mode worksheet for a Clarion data file. Each record 
 appears as a row and each field as a column in a spreadsheet format.
You can use the cursor control keys to scroll through the records in  
the data file and to view any fields right of column 80.  To scroll
and change the current record, use Cursor up and Cursor down, PgUp and
PgDn, and Ctrl-PgUp and Ctrl-PgDn.
Current
Current
record 
field  
 Default display format
Field display label 
 (Change with Ctrl-F)  
(Change with Ctrl-L)
Viewing 
sequence
Current
 Record status  
Current  
record 
(Active/Deleted)
data file
number 
 Cursor left and Cursor right changes the current field. 
 From the right side of the display, Cursor Right will 
 continue to the next set of fields.
*.DAT
PHONES.DAT
 This is the Scanner tutorial.
 Clarion's Scanner utility allows you to inspect and edit 
 Clarion data files and DOS files.
 Clarion data files are inspected in "Record mode",
 whereby records are displayed in a spreadsheet format
 (where fields are displayed as columns and records are
 displayed as rows.)
 For all other types of files, Scanner enters "DOS mode"  
 and displays files in hexadecimal and text formats.
SEARCH/REPLACE
  Search for STRING(20)  :|
  Replace with STRING(20):
Record Number
NAME_KEY
Existing data file will be replaced
The CLARION Sorter
  Input
  Output
  Sort key
  Compress file
Yes  No
  Retain deletions:No
Yes  No
  Remove key files:No
Yes  No
 This is the Sorter tutorial.  It should be viewed 
 after the Filer tutorial.
 The Filer tutorial created a data file from the
 source program generated by the Designer tutorial.
 Now we will use Sorter with this data file.
 From here, our job is easy.  We only want
 Sorter to reorganize the file -- so we do
 not need to specify a Sort key, and we do
 not want to Compress, we do not want to
 Retain deletions, and we do not want to
 Remove key files.  So, all we have to do is 
 press Ctrl-Enter to accept these defaults.  
 That's how easy it is to Reorganize a file.  Now, suppose we wanted 
 to actually Sort our file.  To accomplish this, we need to specify  
 a Sort key, but first, once again, let's leave the input and output 
 files the same by simply pressing Enter.
 A Sort key is made up of one or more sort parameters.  Sort param-  
 eters are field labels and (when more than one is used) they are
 separated by plus or minus signs.
 A plus sign indicates that the next sort parameter should be sorted 
 in ascending sequence.  A minus sign indicates that the next sort
 parameter should be sorted in descending sequence.  If the first
 parameter IS NOT preceded by a plus or minus sign, Sorter assumes
 that you want to sort in ascending sequence.
 Suppose we wanted to sort on the PHN:NAME field in ascending
 sequence.  We must enter the field name, and since it is the first 
 parameter, and since we want ascending sequence, we can omit the
 plus sign.  So we simply type the field name and press Enter.
 Oops! we misspelled PHN:NAME.  No problem, Sorter informs us that  
 there is 'No such field.'  We could just re-key the parameter, but 
 suppose we weren't sure what the field name is.  We can call the
 Sort Key Selection Window to find the right field name by typing a 
 plus (or minus), then blanking the rest of the field by pressing
 Ctrl-End, then pressing Enter.
 There it is!  That's the
 field we want.  All we have 
 to do is press Enter and
 the Sort Key Selection
 Window will deliver the
 selected field name to be
 the sort parameter.
 Now we have a Sort key.  We could add more  
 parameters to our key if we wanted to, and  
 we can call up the Selection Window as many 
 times as necessary.  Each time the Sort key 
 field ends in a + or -, the Sort Key
 Selection Window will appear to help us
 select sort key parameters.
 Now let's Sort.  Again, the rest of fields  
 on the base window already have the correct 
 responses filled in.  We can accept these
 defaults and begin sorting by pressing
 Ctrl-Enter.
 That's how easy it is to Sort a file.  Now, suppose we wanted to
 Compress our file.  To accomplish this, we should specify a backup 
 Output filename.  Let's use the extension .BAK.
 This time we will leave the Sort key field blank, but we need to 
 answer Yes at the Compress file field.
 Sorter provides several commonly-used file
 maintenance functions for use with your Clarion 
 data files 
 Let's suppose that this time we also want our compressed file to 
 include any deleted records.  For this to happen, we must answer 
 Yes at the Retain deletions field.
 The Remove key files field gives us the ability to make a version 
 of this file that has no associated key files.  We do not want to 
 do that this time, so now to begin compressing, all we need to do,
 once again, is press Ctrl-Enter.
 That's how simple it is to Compress a file!  To Restore our file
 from its compressed form, all we need to do is to repeat the steps 
 we used to Reorganize the file, only this time specify PHONEBK.BAK 
 as the input and PHONEBK.DAT as the output.  Once we press Ctrl-
 Enter, Sorter takes care of the rest.  Now let's look at the last  
 major file maintenance function of Sorter 
 Concatenating.
 To Concatenate files of identical format into a single file, all we 
 need to do is tell Sorter all of the Input filenames separated by a 
 plus sign.  Then we provide Sorter with a single Output file name.  
 Let's assume there are two other versions of PHONEBK on our disk;
 one in a directory called \USER1 and the other in \USER2.
 Sorter defaults the Output filename to be same as the first Input 
 file.  Let's suppose that we want the output file to be in the
 current directory, which is \PHONES.
 Now we are ready to Concatenate.  Let's use the rest of the fields 
 the way they are -- set to the normal defaults.  When we press
 Ctrl-Enter, Sorter will build a new file from two other files.
 And that's all there is to Concatenating.  We have looked at each  
 of the major features of Sorter --
Reorganizing, Sorting, Compressing, Restoring, and Concatenating 
 This completes the Sorter tutorial.  Let's return to the tutorial  
 menu.
S o r t i n g
 Sorter can sort, or physically rearrange, the order 
 of the records in a Clarion data file when you
 specify an order sequence.
(Name) (Age)
 Zeb  
 Adam 
 Adam 
 Bob  
 Sorter 
 Cory 
 Cory 
 (Sort on the 
 Bob  
  Name field) 
 Zeb  
R e o r g a n i z i n g
  Sorter can reorganize a data file by removing
  deleted records.  Sorter reorganizes key files by  
  rebuilding them from the data file.
 Zeb  
Reorg'd Data
Reorg'd Key 
 Adam 
 Zeb  
 Sorter
  deleted  
 Adam 
 Bob  
 Bob  
C o m p r e s s i n g  /  R e s t o r i n g
 Sorter can compress a data file--making backup
 and data distribution easier.  When you run a
 compressed data file through Sorter, Sorter auto-
 matically restores it AND rebuilds any of its keys. 
 Key file  
  Compressed data file
 Key file  
PHONEBK.K01
PHONEBK.K01
PHONEBK.BAK
 Data file 
 Data file 
PHONEBK.DAT
PHONEBK.DAT
> Sorter 
C o n c a t e n a t i n g
  Sorter can concatenate data files that have the
  same record layout.  That is, files of the same
  format containing different data can be combined.  
 \USER1\
\WORK\
 PHONEBK.DAT 
 \USER2\
Sorter 
 PHONEBK.DAT 
 PHONEBK.DAT 
 This is Sorter's base window.  Clarion remembers 
 that we are working on the file PHONEBK.DAT. So  
 to use Sorter with this file, all we have to do  
 is press Enter.
 Sorter assumes that we want the Output file- 
 name to be the same as the Input filename.
 In this example, this is exactly what we
 want.  We want to use Sorter to reorganize
 our file (free deleted space and rebuild the 
 key file.)  To accept the Output filename,
 all we have to do is press Enter.
 Sorter informs us that the existing file
 PHONEBK.DAT will be replaced since we used the 
 same name for Input and Output.  If this was
 not what we wanted to do, we could back up by  
 pressing Escape and then enter a different
 Output filename.  This time, however, this is  
 what we want to do, so we will proceed.
Press Enter to scan file
Active recs  :
File size  :
2,240 Deleted recs :
Change date:  3/31/88 Record length:
Change time:  11:31AM 
FILE,PRE(PHN),RECLAIM,CREATE
NAME_KEY
KEY(PHN:NAME),DUP,NOCASE
RECORD
RECORD
STRING(20)
ADDRESS
STRING(30)
CITY_ST
STRING(30)
PHONE
DECIMAL(11,0)
 &. .
 This is the Converter tutorial.
 Clarion's Converter utility will import a dBaseII,
 dBase
, DIF, or BASIC file, convert it to a Clarion 
 data file, and produce a Clarion FILE structure for
 the converted file.  Similarly, Converter can export  
 a Clarion data file and convert it to a dBaseII,
 dBase
, DIF, or BASIC file.
33912
ADDRESS 
BYNAME  4
BYRECNO 
CITY_ST 
CONVERT 
CVT1    
CVT1_W1 V
CVT1_W2 
CVT1_W3 
CVT1_W4 
CVT1_W5 
CVT1_W6 
CVT1_W7 >
CVT1_W8 
CVT1_W9 p
DOSMODE 
ENTERDOSF"
FIELDS  >#
FIL     
FIL_W1  
FIL_W2  
FIL_W3  q*
FIL_W4  U+
FIL_W5  Y,
FIL_W6  
FIL_W7  ;.
FIL_W8  [/
FLD1    U0
FLD2    
FLD3    &4
GETFILE 
MOVE1   
MOVE2   H6
MOVE3   
NAME    Y?
NAME2   
NAME_KEY
NEXTPAGE
OUTPUT  
PHONE2  
PHONE_A 6F
PHONE_B [F
PICKDBF 
PUTFILE 
SCN1    
SCN1_W1 4K
SCN1_W10cM
SCN1_W11xN
SCN1_W12
SCN1_W13
SCN1_W14
SCN1_W15
SCN1_W16
SCN1_W17cW
SCN1_W18
SCN1_W19
SCN1_W2 VZ
SCN1_W20&[
SCN1_W21
SCN1_W22j`
SCN1_W3 
SCN1_W4 
SCN1_W5 
SCN1_W6 
SCN1_W7 
SCN1_W8 
SCN1_W9 
SCN_GET {k
SCN_TTL1
SEARCH  
SEQUENCE
SOURCE  
SRT     
SRT_W1  
SRT_W10 
SRT_W11 hv
SRT_W12 
SRT_W13 "z
SRT_W14 q{
SRT_W15 >}
SRT_W16 3~
SRT_W17 
SRT_W18 
SRT_W19 
SRT_W2  T
SRT_W20 
SRT_W21 
SRT_W22 
SRT_W23 
SRT_W24 
SRT_W25 
SRT_W26 
SRT_W3  
SRT_W4  k
SRT_W5  
SRT_W6  _
SRT_W7  (
SRT_W8  
SRT_W9  
STRUCTURW
TTL1    0
WHITE   
ZIP